<#function _getType row>
    <#if row.type == 'CHAR' || row.type == 'VARCHAR' || row.type == "TINYTEXT" || row.type == "TEXT" || row.type == "MEDIUMTEXT" || row.type == "LONGTEXT"><#return "String" /></#if>
    <#if row.type == 'TINYBLOB' || row.type == 'BLOB' || row.type == 'MEDIUMBLOB' || row.type == 'LONGBLOB'><#return "byte[]" /></#if>
    <#if row.type == 'TINYINT' && row.length == 1><#return "Boolean" /></#if>
    <#if row.type == 'TINYINT'><#return "Byte" /></#if>
    <#if row.type == 'BIGINT'><#return "Long" /></#if>
    <#if row.type == 'SMALLINT' || row.type == 'INT' || row.type == 'INTEGER' || row.type == 'MEDIUMINT'><#return "Integer" /></#if>
    <#if row.type == 'FLOAT' || row.type == 'DOUBLE' || row.type == 'NUMERIC' || row.type == 'DECIMAL'><#return "BigDecimal" /></#if>
    <#if row.type == 'DATE' || row.type == 'DATETIME' || row.type == 'TIMESTAMP'><#return "Date" /></#if>
    <#if row.type == 'TIME'><#return "Time" /></#if>
    <#if row.type == 'YEAR'><#return "Integer" /></#if>
    <#return "String"/>
</#function>
<#function getImports datas>
  <#assign imports=""/>
  <#list datas as data>
    <#if _getType(data)== "Date" && imports?index_of("java.util.Date") == -1><#assign imports+="import java.util.Date;\n"/>
    <#elseif _getType(data) == "BigDecimal" && imports?index_of("java.math.BigDecimal") == -1><#assign imports+="import java.math.BigDecimal;\n"/>
    <#elseif _getType(data) == "Time" && imports?index_of("java.sql.Time") == -1><#assign imports+="import java.sql.Time;\n"/></#if>
  </#list>
<#return imports/>
</#function>
